Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.310 lượt xem;
- sanpham.aspx.cs
- project /
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using SiteUtils;
12 using System.Data.OleDb;
13 public partial class sanpham : System.Web.UI.Page
14 {
15 GioHangData gh;
16 DataTable dt;
17 DataSet ds1;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20
21 if (!IsPostBack)
22 {
23 ado.ketNoi();
24 string query = "Select*,'chitiet.aspx?tensp='+tensp as chitiet from tblsanpham where mahang='" + Request.QueryString.Get("mahang") + "'";
25 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
26 DataSet dataset = new DataSet();
27 adapter.Fill(dataset);
28 clp1.PageSize = 12;
29 clp1.DataSource = dataset.Tables[0].DefaultView;
30 clp1.BindToControl = DataList1;
31 DataList1.DataSource = clp1.DataSourcePaged;
32 //Download source code tại Sharecode.vn
33
34 }
35
36 }
37
38 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
39 {
40
41 }
42 protected void Button1_Click(object sender, EventArgs e)
43 {
44
45 }
46
47 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
48 {
49 ado.ketNoi();
50 Label lbg = (Label)DataList1.Items[DataList1.SelectedIndex].FindControl("Label10");
51 HyperLink hy = (HyperLink)DataList1.Items[DataList1.SelectedIndex].FindControl("HyperLink1");
52
53
54 lbg.Visible = true;
55 gh = new GioHangData();
56 DataTable tb;
57 if (Session["GioHang"] == null)
58 tb = gh.setTable();
59 else
60 tb = (DataTable)Session["GioHang"];
61 string query = "select * from tblSanPham where masp='"+hy.Text+"'";
62
63 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
64 DataTable dt = new DataTable();
65 da.Fill(dt);
66 foreach (DataRow dr in dt.Rows)
67 {
68 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
69 Session["GioHang"] = tb;
70 }
71
72
73 }
74 protected void btDau_Click(object sender, EventArgs e)
75 {
76
77 }
78
79 protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
80 {
81
82 }
83 protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
84 {
85
86
87 }
88 protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
89 {
90
91 }
92 protected void ImageButton2_Command(object sender,System.Web.UI.WebControls.CommandEventArgs e)
93 {
94
95 }
96
97 }
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using SiteUtils;
12 using System.Data.OleDb;
13 public partial class sanpham : System.Web.UI.Page
14 {
15 GioHangData gh;
16 DataTable dt;
17 DataSet ds1;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20
21 if (!IsPostBack)
22 {
23 ado.ketNoi();
24 string query = "Select*,'chitiet.aspx?tensp='+tensp as chitiet from tblsanpham where mahang='" + Request.QueryString.Get("mahang") + "'";
25 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
26 DataSet dataset = new DataSet();
27 adapter.Fill(dataset);
28 clp1.PageSize = 12;
29 clp1.DataSource = dataset.Tables[0].DefaultView;
30 clp1.BindToControl = DataList1;
31 DataList1.DataSource = clp1.DataSourcePaged;
32 //Download source code tại Sharecode.vn
33
34 }
35
36 }
37
38 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
39 {
40
41 }
42 protected void Button1_Click(object sender, EventArgs e)
43 {
44
45 }
46
47 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
48 {
49 ado.ketNoi();
50 Label lbg = (Label)DataList1.Items[DataList1.SelectedIndex].FindControl("Label10");
51 HyperLink hy = (HyperLink)DataList1.Items[DataList1.SelectedIndex].FindControl("HyperLink1");
52
53
54 lbg.Visible = true;
55 gh = new GioHangData();
56 DataTable tb;
57 if (Session["GioHang"] == null)
58 tb = gh.setTable();
59 else
60 tb = (DataTable)Session["GioHang"];
61 string query = "select * from tblSanPham where masp='"+hy.Text+"'";
62
63 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
64 DataTable dt = new DataTable();
65 da.Fill(dt);
66 foreach (DataRow dr in dt.Rows)
67 {
68 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
69 Session["GioHang"] = tb;
70 }
71
72
73 }
74 protected void btDau_Click(object sender, EventArgs e)
75 {
76
77 }
78
79 protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
80 {
81
82 }
83 protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
84 {
85
86
87 }
88 protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
89 {
90
91 }
92 protected void ImageButton2_Command(object sender,System.Web.UI.WebControls.CommandEventArgs e)
93 {
94
95 }
96
97 }